UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zxm8TPgjmXcwMQkBeKZuiOk30kNTPijJ4rAGIrfNh7o='
WHERE
key_id = '3b256a0886de21d886f5bc8fb9014e6e9fccdf338a436ce0cf6811a5a1f62138'
AND (
token = 'zxm8TPgjmXcwMQkBeKZuiOk30kNTPijJ4rAGIrfNh7o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)