UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9yhKKZ9i/0X14DI/CaZD2elpRXIGSqO4rv8DIIeupc8='
WHERE
key_id = '5387468a9605bc78228054311534d10c966e6febe75009f1d959a6dd4e83bf63'
AND (
token = '9yhKKZ9i/0X14DI/CaZD2elpRXIGSqO4rv8DIIeupc8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)