UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QNOKIJ819gGRHPquyVg9kwOrdA9X0ATHUq+7MnixVFA='
WHERE
key_id = '112273464d96198b0997be5501d13ac810786f51a2e42623959e78333dd8cc17'
AND (
token = 'QNOKIJ819gGRHPquyVg9kwOrdA9X0ATHUq+7MnixVFA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)