UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '46ahBO4pc3SY8Ye/tGtacKWfL9u26loEs1gI3LuEHA8='
WHERE
key_id = '06b21827ea5b3829e0b913e582a6b8ff1fd8328be22b19b053a1728f93559039'
AND (
token = '46ahBO4pc3SY8Ye/tGtacKWfL9u26loEs1gI3LuEHA8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)