UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z2GQo0clMExzzZrJ1lMGgealPmqLAxXF5Y8iVzqUhTs='
WHERE
key_id = '64e648304ac9d1034c9d725685572cca323ba7ff6c901e69bc429a44b7a6b972'
AND (
token = 'z2GQo0clMExzzZrJ1lMGgealPmqLAxXF5Y8iVzqUhTs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)