UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'IWCihGd3j3sOCyfDp1iqIqGHO1KKWNt91E2BVXwlzEA='
WHERE
key_id = 'a2f77e100df9d99f1bd52f51c7fa5c66a7aeee7c8cbc7df27b0fab4ecf6d8c75'
AND (
token = 'IWCihGd3j3sOCyfDp1iqIqGHO1KKWNt91E2BVXwlzEA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)