UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/WGYd3nhvr5xx6Q1ZCJq3i8PPqXNBdjqnocfHr/qXMQ='
WHERE
key_id = 'ff4c391e0af66bc797537fbcac248772968756a2d178deddb0a8401ec728f380'
AND (
token = '/WGYd3nhvr5xx6Q1ZCJq3i8PPqXNBdjqnocfHr/qXMQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)