UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gtl5opCINIJFlo1/Z537utAISG1pt+OLqwVGE8T4Bdw='
WHERE
key_id = 'b5edc8687063f38ee4fb028cd01bad878e98a1eab74ca1d1cb5f86999cf0fbe0'
AND (
token = 'gtl5opCINIJFlo1/Z537utAISG1pt+OLqwVGE8T4Bdw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)