UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nNi+nNv2iyiqLbJZ703EX49qSpAkRtSus97dU1oEZcc='
WHERE
key_id = 'a46ed27a8d578f9d56a628a865193a30dcfa3d9c79e97c3461dd1366af0498cc'
AND (
token = 'nNi+nNv2iyiqLbJZ703EX49qSpAkRtSus97dU1oEZcc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)