UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oFq3C//nZ8dt28PJtx+FB7AVvUGVGV56bFzlCXLOosA='
WHERE
key_id = '47ddddc6768f758a639c9b2b9336ad15a774832f3550305f07a13364ab7565bf'
AND (
token = 'oFq3C//nZ8dt28PJtx+FB7AVvUGVGV56bFzlCXLOosA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)