UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NM5wulJSuWIzpUm7VcJG6YLOpkSKE2q8vlCkcXtaaFE='
WHERE
key_id = 'dfc2cb14bab97ee1dee1334a7a111e5e0c59b21d178cc28e4495d212a87cf208'
AND (
token = 'NM5wulJSuWIzpUm7VcJG6YLOpkSKE2q8vlCkcXtaaFE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)