UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zorJG9+QHl6DMF3Ol5Tbk5hb3ch9Cc8GU02Sk64QNHw='
WHERE
key_id = '2775307b4a6b0ae6612db94f0e326b267d975231a44f04321fa9238caea95269'
AND (
token = 'zorJG9+QHl6DMF3Ol5Tbk5hb3ch9Cc8GU02Sk64QNHw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)