UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7EcvYkjeauEcmEhA/+G6+r4ndPjPIMg3rbeyDk0tFu4='
WHERE
key_id = 'b9887f026bdab0b73e0406eab4d8c237834fd2747f18de3a661347ea1c201bb2'
AND (
token = '7EcvYkjeauEcmEhA/+G6+r4ndPjPIMg3rbeyDk0tFu4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)