UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HuP1qVzgN4BDyf+ChMLumt8M/ZsS1JfCYtAVHbXe+lY='
WHERE
key_id = 'b679c1dc423d557cb3783e442c1ebc1b922f177ef3f226a8be5e7d00cf94b7d0'
AND (
token = 'HuP1qVzgN4BDyf+ChMLumt8M/ZsS1JfCYtAVHbXe+lY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)