UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'l7DKGNCURcM3IXw8B/pO9Z6rG/745ZLe4ee7M0E9nC8='
WHERE
key_id = '6cf6046b6ba0454c0a3913188dc8f55b645b22b4ecec8232722599be27425c13'
AND (
token = 'l7DKGNCURcM3IXw8B/pO9Z6rG/745ZLe4ee7M0E9nC8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)