UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vmLPFYOV8sXUY4xylvE3zSrcxm1q7byGPs5pKsHZtJc='
WHERE
key_id = '0ac16986e597a3f07eee25430f8c1a374a1010b44fb563f3104c6a5793b30264'
AND (
token = 'vmLPFYOV8sXUY4xylvE3zSrcxm1q7byGPs5pKsHZtJc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)