UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'J09TJec8W6RRbGqmAPBS7Ikrd+8E5iqLreksfeyXSYk='
WHERE
key_id = 'bf5fa7a569426d2b1199bc05123aae99d835d04f70aae36b46b084dde77a9553'
AND (
token = 'J09TJec8W6RRbGqmAPBS7Ikrd+8E5iqLreksfeyXSYk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)