UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6WXyS/z8oH/Cx/nv2xfYHZ//mHDcpKDH229BOiQKfBg='
WHERE
key_id = '4b08f64de27cf1bac6bbe17cb9a172399c895707042c4ed5301cd5689ca0294a'
AND (
token = '6WXyS/z8oH/Cx/nv2xfYHZ//mHDcpKDH229BOiQKfBg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)