UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3fhJwjXtT2A5wKFVN/3BqjnOGo6V9ui5EMyqg8hyGiA='
WHERE
key_id = 'ac9c397d83704b429b0e3364472a2e1141a5d89835368b9e6ecfa29e5ff6beb1'
AND (
token = '3fhJwjXtT2A5wKFVN/3BqjnOGo6V9ui5EMyqg8hyGiA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)