UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'irU8YklqZA2Atz92rINw1zmXy6awWonSIfQzXm7lc9s='
WHERE
key_id = 'bffe34a83d136d07272562da8d6c4363eeefabd37841c1eaf5f378b345ebe69f'
AND (
token = 'irU8YklqZA2Atz92rINw1zmXy6awWonSIfQzXm7lc9s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)