UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'iLcEj72cHkcAdDFV/WjKNbz/2/zDoelKX9BjCG5cHEs='
WHERE
key_id = '7eef813de668beda306d269620710cf2f7588bdb228dd5670b7071c2d8ac5799'
AND (
token = 'iLcEj72cHkcAdDFV/WjKNbz/2/zDoelKX9BjCG5cHEs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)