UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rIqNOrOpSVV2qTHPXx/z4OPoR5G4Az+DhTlfJHSHuwQ='
WHERE
key_id = 'a6848185bc27469524dd744695d560ec5157b0bee7725a475b3483a2018c68bf'
AND (
token = 'rIqNOrOpSVV2qTHPXx/z4OPoR5G4Az+DhTlfJHSHuwQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)