UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'v9d8yhXPxOoTm/5XD7/cTxHwOEFvzKRzCj9jsgiAco8='
WHERE
key_id = '8b21b372053e428f871a3ef5440d07ada209fc25b0bb8053d3d89e9f2582612d'
AND (
token = 'v9d8yhXPxOoTm/5XD7/cTxHwOEFvzKRzCj9jsgiAco8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)