UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2IIGLOQeofB31i5HM9IVIa1ev+Pn3ZMrlAfylzyx2LY='
WHERE
key_id = 'd3767bed12d688d6b6664ed84bf720f437057c767314b642045eaa5ff1514a0e'
AND (
token = '2IIGLOQeofB31i5HM9IVIa1ev+Pn3ZMrlAfylzyx2LY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)