UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WKfpytepmzL60e/U44AO7K8kwyPI7GB0znvXNWozkfI='
WHERE
key_id = '3edff022d5ddc92b27eda38ca67dc6e22b5754bdf4bbe015a4f6c87ff3f190c0'
AND (
token = 'WKfpytepmzL60e/U44AO7K8kwyPI7GB0znvXNWozkfI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)