UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z5pKLXlNW/uJ1/QN8PXb7THgMN4TPxPsd9LxJ95SzDo='
WHERE
key_id = 'f89b1759f13018e78e55499661287a05ff3028d9b11467036f736c26dec66a8a'
AND (
token = 'z5pKLXlNW/uJ1/QN8PXb7THgMN4TPxPsd9LxJ95SzDo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)