UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'x8jycHrLv5HewbBJuO8MRtO3yU56tcjd9owkjvvpzqc='
WHERE
key_id = '7e890d0bbbe3cee3bc1a66d76f21c97e5b40a33cc3cc40f9503f84ad51ef23e6'
AND (
token = 'x8jycHrLv5HewbBJuO8MRtO3yU56tcjd9owkjvvpzqc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)