UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6JIqludPYvgARL9d2fzubkyLf+O2+xa7F2nuL7+t0fI='
WHERE
key_id = '3788d54f8d1c6f2942907fc1c873ff2e11eb489d42ef0880a205a293ece90a6e'
AND (
token = '6JIqludPYvgARL9d2fzubkyLf+O2+xa7F2nuL7+t0fI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)