UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cle+S1SXjCyqe69EfN9mEUnpgcpMkXIuOWESzpjomxo='
WHERE
key_id = 'd9266399ea2cc171485635c94bf69f34a9197a0333749edfde4b418fb0742710'
AND (
token = 'cle+S1SXjCyqe69EfN9mEUnpgcpMkXIuOWESzpjomxo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)