UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yqjKVZyKZCsZx3x2ATjWOQDIfZzZ0z2M/2V3o4yCipw='
WHERE
key_id = 'd6ea808805b1794329a93090ea18306e9ba8c1b7640ed9760bdfa59e10eaaf68'
AND (
token = 'yqjKVZyKZCsZx3x2ATjWOQDIfZzZ0z2M/2V3o4yCipw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)