UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RQHzY72iDY3Z2DVqN+ToFC67PGb4PUSCZSCTwmZwGOk='
WHERE
key_id = '7a5d24e09ae05e344dd708e4b85276b31167d746c469c8241d2b96306e4c4287'
AND (
token = 'RQHzY72iDY3Z2DVqN+ToFC67PGb4PUSCZSCTwmZwGOk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)