UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'a8dU+Klob64fAMW38WW0167dWzPFCdqvhvj+D4lM0Ns='
WHERE
key_id = 'cff3101bb3be9124ed2f0b234c3845da2cb609d554034d864cbe525b728f481f'
AND (
token = 'a8dU+Klob64fAMW38WW0167dWzPFCdqvhvj+D4lM0Ns='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)