UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'S1VAvogdxDADrWJpxiHppYguSvJoP+iH+0iJcAjGeag='
WHERE
key_id = '98a7d307de742e518c77ba564fb648babf4f4519b6debaa257e1af31cbfeb62d'
AND (
token = 'S1VAvogdxDADrWJpxiHppYguSvJoP+iH+0iJcAjGeag='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)