UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'O/lLBJ+/3kegSHNC6aNcdejPVFTVOEwARc8jN4u9cXU='
WHERE
key_id = '2013c5e9c1cb2c3cface6cf062098b366b5d81f7b445d3a363b3ee1456aad438'
AND (
token = 'O/lLBJ+/3kegSHNC6aNcdejPVFTVOEwARc8jN4u9cXU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)