UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BAxc9SM0rmdvtTwvCiEjYbIbgGNXaZSubjF5VmkfkCg='
WHERE
key_id = '4bdcd2d610593ec8ce882fea6f1d0227106aa898eedd67c9888fa8d4bd820053'
AND (
token = 'BAxc9SM0rmdvtTwvCiEjYbIbgGNXaZSubjF5VmkfkCg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)