UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8KG7qhrr9yqF0wNSDGovwzkhn91bmbeROm1ytmc+o48='
WHERE
key_id = '1dda6d92b0f335fd7ed21858b78747a6150e4d9d310fc63ba0534de95ee11cf7'
AND (
token = '8KG7qhrr9yqF0wNSDGovwzkhn91bmbeROm1ytmc+o48='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)