UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cCW04aTKk/g3K+M3iP5iIdfxo9wSda1P6I48BKYCsF4='
WHERE
key_id = 'a4266e5054a1120f2da73cc2465c28986639cf3ef16218bd700d3f64541da784'
AND (
token = 'cCW04aTKk/g3K+M3iP5iIdfxo9wSda1P6I48BKYCsF4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)