UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gydvVyPPw8annZMkZyvL4E8rZZG0GGB7bOAi6elv4Zk='
WHERE
key_id = 'c9628f17c3478ca4dd4143bac6df719a8f84fb53adfb469011ec5a44ba4c8ad8'
AND (
token = 'gydvVyPPw8annZMkZyvL4E8rZZG0GGB7bOAi6elv4Zk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)