UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Zm9CYgeq7tu002+nOx5XHdB0gjjlt8r9j5etU9yy0CM='
WHERE
key_id = 'b65c7444d2bb0db9cefae0cd0c0ab8f3fc2b800c43a4170af49db1c2553d8c68'
AND (
token = 'Zm9CYgeq7tu002+nOx5XHdB0gjjlt8r9j5etU9yy0CM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)