UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pnfQwp0n7x8F9rVKEEIEzRE/1nfhrLxMSSu2icmbjXU='
WHERE
key_id = '559da4b6b694c3a57f606690bcd61a699d078421d18cc2db78fa053c968e24ae'
AND (
token = 'pnfQwp0n7x8F9rVKEEIEzRE/1nfhrLxMSSu2icmbjXU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)