UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oYosbYLmePQiRgFuc4klcbA17A9LKpr06/wjVHhnF54='
WHERE
key_id = '1eb9bff605a184f0624357fedb683921c40a7b51fb0ed532ba942a60e79e9847'
AND (
token = 'oYosbYLmePQiRgFuc4klcbA17A9LKpr06/wjVHhnF54='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)