UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'teBWTNYBXMTbN8G5T0swVGwc4N2CAVZs3mE0CZK7Fg8='
WHERE
key_id = '1c81f3782134b2b7da1b831cbbd80c030767423d5ad50c6997eb78d96c65eb46'
AND (
token = 'teBWTNYBXMTbN8G5T0swVGwc4N2CAVZs3mE0CZK7Fg8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)