UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xj0VdGjoU4Va3tV3guZA/9GuxkhwbbIxnkAwaEB4UJY='
WHERE
key_id = 'c3df091300b1b4ba28368d17280271cf07e0308a44ef9ec31df64e13e0a9db9c'
AND (
token = 'xj0VdGjoU4Va3tV3guZA/9GuxkhwbbIxnkAwaEB4UJY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)