UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'J5Zw/QpGExp4OG2v+tAXnPqqNxEXTKhQEtTe22BQ0zQ='
WHERE
key_id = 'caec2d3cfc30983da8a7a0707642d9ecb8e4f60948e4619a3df2ac5e1c476087'
AND (
token = 'J5Zw/QpGExp4OG2v+tAXnPqqNxEXTKhQEtTe22BQ0zQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)