UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jjzQPhDV11D4J7k4pEEeX37kFBC+BgrfDRTY+oiZnAc='
WHERE
key_id = '428d9c65cde9f6bdd5438e6e88e75fedad45e85270434538d0c66abf92f64908'
AND (
token = 'jjzQPhDV11D4J7k4pEEeX37kFBC+BgrfDRTY+oiZnAc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)