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